<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
 <head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  <title>Supported Datatypes</title>
<link media="all" rel="stylesheet" type="text/css" href="styles/03e73060321a0a848018724a6c83de7f-theme-base.css" />
<link media="all" rel="stylesheet" type="text/css" href="styles/03e73060321a0a848018724a6c83de7f-theme-medium.css" />

 </head>
 <body class="docs"><div class="navbar navbar-fixed-top">
  <div class="navbar-inner clearfix">
    <ul class="nav" style="width: 100%">
      <li style="float: left;"><a href="oci8.dtrace.html">« OCI8 and DTrace Dynamic Tracing</a></li>
      <li style="float: right;"><a href="ref.oci8.html">OCI8 函数 »</a></li>
    </ul>
  </div>
</div>
<div id="breadcrumbs" class="clearfix">
  <ul class="breadcrumbs-container">
    <li><a href="index.html">PHP Manual</a></li>
    <li><a href="book.oci8.html">OCI8</a></li>
    <li>Supported Datatypes</li>
  </ul>
</div>
<div id="layout">
  <div id="layout-content"><div id="oci8.datatypes" class="chapter">
 <h1>Supported Datatypes</h1>

 <table class="doctable table">
  <caption><strong>The driver supports the following types when binding parameters using the
   <span class="function"><a href="function.oci-bind-by-name.html" class="function">oci_bind_by_name()</a></span> function:</strong></caption>
  
   <thead>
    <tr>
     <th>Type</th>
     <th>Mapping</th>
    </tr>

   </thead>

   <tbody class="tbody">
    <tr>
     <td><strong><code>SQLT_NTY</code></strong></td>
     <td>Maps a native collection type from a PHP collection object,
      such as those created by <span class="function"><a href="function.oci-new-collection.html" class="function">oci_new_collection()</a></span>.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_BFILEE</code></strong></td>
     <td>Maps a native descriptor, such as those created by
      <span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_CFILEE</code></strong></td>
     <td>Maps a native descriptor, such as those created by
      <span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_CLOB</code></strong></td>
     <td>Maps a native descriptor, such as those created by
      <span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_BLOB</code></strong></td>
     <td>Maps a native descriptor, such as those created by
      <span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_RDD</code></strong></td>
     <td>Maps a native descriptor, such as those created by
      <span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_NUM</code></strong></td>
     <td>Converts the PHP parameter to a &#039;C&#039; long type, and binds to
      that value.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_RSET</code></strong></td>
     <td>Maps a native statement handle, such as those created by
      <span class="function"><a href="function.oci-parse.html" class="function">oci_parse()</a></span> or those retrieved from other OCI queries.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_BOL</code></strong></td>
     <td>Bind the PHP parameter to a PL/SQL BOOLEAN</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_CHR</code></strong> and any other type</td>
     <td>Converts the PHP parameter to a string type and binds as a
      string.</td>
    </tr>

   </tbody>
  
 </table>


 <table class="doctable table">
  <caption><strong>The following types are supported when retrieving columns from a result set:</strong></caption>
  
   <thead>
    <tr>
     <th>Type</th>
     <th>Mapping</th>
    </tr>

   </thead>

   <tbody class="tbody">
    <tr>
     <td><strong><code>SQLT_RSET</code></strong></td>
     <td>Creates an oci statement resource to represent the cursor.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_RDD</code></strong></td>
     <td>Creates a ROWID object.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_BLOB</code></strong></td>
     <td>Creates a LOB object.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_CLOB</code></strong></td>
     <td>Creates a LOB object.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_BFILE</code></strong></td>
     <td>Creates a LOB object.</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_LNG</code></strong></td>
     <td>Bound as SQLT_CHR, returned as a string</td>
    </tr>

    <tr>
     <td><strong><code>SQLT_LBI</code></strong></td>
     <td>Bound as <strong><code>SQLT_BIN</code></strong>, returned as a string</td>
    </tr>

    <tr>
     <td>Any other type</td>
     <td>Bound as <strong><code>SQLT_CHR</code></strong>, returned as a string</td>
    </tr>

   </tbody>
  
 </table>

</div>
</div></div></body></html>